Versions:

2.0.0
1.8.0
1.7.4
1.7.3
1.7.2
1.7.1
1.7.0
1.6.3
1.6.2
1.6.1
1.6.0
1.5.3
1.5.2
1.5.1
1.5.0
1.4.0
1.2.0
1.1.0
1.0.0
0.11.0
0.10.1
0.10.0
0.9.6
0.9.5
0.9.4

grate is a cross-platform, open-source migration engine for Microsoft SQL Server that brings database change management into the 2020s by replacing older tools with a forward-looking, .NET-based workflow. Designed for DevOps and CI/CD pipelines, it parses versioned folders of SQL scripts and applies them in deterministic order, tracking every executed script in a dedicated versioning table so that teams can confidently promote schema changes from local development through test, staging, and production environments. Typical use cases include automated database deployments inside Azure DevOps, GitHub Actions, or Jenkins pipelines, repeatable environment provisioning for integration tests, and zero-downtime updates of SaaS products that serve hundreds of databases per customer. Because grate is distributed as a single self-contained executable, it can be invoked on Windows, macOS, or Linux build agents without installing heavy client tools, and it supports modern authentication methods such as Azure AD and MSI alongside traditional SQL logins. The project, maintained by publisher erikbra, has iterated through twenty-five public releases; the current stable line is 2.0.0, which introduced parallel execution of non-destructive scripts, improved memory footprint for large migration sets, and a configurable batch separator that accommodates T-SQL scripts generated by SSMS. Earlier 1.x versions remain available for organizations that need legacy .NET Framework compatibility, while nightly builds offer pre-release features for early adopters. grate is available for free on get.nero.com, with downloads provided via trusted Windows package sources (e.g. winget), always delivering the latest version, and supporting batch installation of multiple applications.

Tags: